----------------------------------------------------------------------------------
      name:  <unnamed>
       log:  G:\My Drive\Research\CTC expansion\submission\ntj\stata replication f
> iles/output/tableA4.log
  log type:  text
 opened on:   3 Dec 2023, 18:19:07

. 
. version 16      

. 
. use "$data/acsmergeddata.dta", clear

. 
. *** total adults
. gen pop=(perwt + spouseperwt)

. egen totadults=sum(pop)

. di totadults
63164152

. drop pop

. 
. gen pop=(newnumkidswt17)

. egen totkids=sum(pop)

. di totkids
72755400

. drop pop

. 
. gen all=1

. replace newnumkidswt17=round(newnumkidswt17,1)
(586 real changes made)

. bysort statefip: egen stnumkids=sum(newnumkidswt17)

. 
. gen poorkids=(poor==1)*newnumkidswt17

. bysort statefip: egen stpoorkids=sum(poorkids)

. sum stpoorkids

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  stpoorkids |    356,390    580168.4      590284      10720    1894790

. 
. gen stillpoor=(poor==1 & poorctc21==1)*newnumkidswt17

. bysort statefip: egen ststillpoor=sum(stillpoor)

. sum ststillpoor

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
 ststillpoor |    356,390      415351    446263.8       6404    1445588

. 
. table statefip [fw=newnumkidswt17], c(n all mean faminc mean stpoorkids mean sts
> tillpoor) 

----------------------------------------------------------------------------------
   state (fips code) |         N(all)   mean(faminc) mean(stpoor~s) mean(ststil~r)
---------------------+------------------------------------------------------------
             alabama |        1072619        66712.3         179620         116878
              alaska |        183,657       97484.54          21932          12341
             arizona |        1611887       76996.34         271752         170329
            arkansas |        699,235       65490.99          93139          58544
          california |        8972903       91349.89        1894790        1445588
            colorado |        1244439       91692.95         145925         104456
         connecticut |        734,631       109132.9          88972          62458
            delaware |        201,434       84214.91          29904          19477
district of columbia |        122,086       107946.3          27092          19405
             florida |        4153042       76736.09         796211         584626
             georgia |        2482557       75374.12         398825         262912
              hawaii |        300,554        91817.1          51291          38492
               idaho |        438,588       75154.62          41114          29681
            illinois |        2868673       88617.33         392586         258318
             indiana |        1554411       73367.98         202834         132228
                iowa |        724,240       79848.44          49532          26221
              kansas |        699,960       80478.14          69167          42639
            kentucky |        997,013       69370.48         153778         106131
           louisiana |        1096514       69512.07         222927         140390
               maine |        250,233       78288.16          19998          11739
            maryland |        1333160       100941.3         199312         150669
       massachusetts |        1353409         110500         188403         138671
            michigan |        2150064       77686.08         276154         168694
           minnesota |        1277407       94058.19          98339          62498
         mississippi |        704,684        60760.7         132189          79806
            missouri |        1367950       74920.35         168315         115551
             montana |        225,661       79215.97          20721          13413
            nebraska |        469,882       78961.84          35951          20606
              nevada |        676,816       78298.05         101873          63830
       new hampshire |        255,663       104978.3          22941          15596
          new jersey |        1959407       109519.3         283879         215005
          new mexico |        481,733        64028.5          78374          50487
            new york |        4089327       93507.95         789686         593655
      north carolina |        2275732        73949.6         357083         231309
        north dakota |        170,429       86614.85          11472           9010
                ohio |        2566094       78205.65         310743         193788
            oklahoma |        946,117       69044.88         120308          70265
              oregon |        863,901       79402.68         104457          63633
        pennsylvania |        2625434       86334.18         358286         241296
        rhode island |        204,564       87302.44          24952          18064
      south carolina |        1086972       67920.43         172990         117111
        south dakota |        207,792       86231.59          19907          10057
           tennessee |        1484983       74537.92         226040         153330
               texas |        7285182       80633.16        1201392         794488
                utah |        919,123        84812.2          82239          52580
             vermont |        114,380       76924.12          10720           6404
            virginia |        1848761       93425.13         272535         205797
          washington |        1629912          94791         183163         122917
       west virginia |        365,941       62971.41          60551          38250
           wisconsin |        1269944       83335.01          98868          57344
             wyoming |        136,595       76318.72          13748          10242
----------------------------------------------------------------------------------

. 
. gen adultsstopwork=.
(356,390 missing values generated)

. gen dynamicantipovkid=.
(356,390 missing values generated)

. 
. levelsof statefip, local(levels)
1 2 4 5 6 8 9 10 11 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
>  34 35 36 37 38 39 40 41 42 44 45 46 47 48 49 50 51 53 54 55 56

.         foreach l of local levels {
  2.         di "-> statefip = `: label (statefip) `l''"
  3. 
. * row 1
. gen group=(married==0)*(incwage>0)*(v25>0)*(agi2017<80000)*(calckids>0)*(samplej
> ustwomen==1)*(statefip==`l')
  4. gen group1=perwt*avgtax*.4*group
  5. egen totgroup1a=sum(group1)
  6. 
. drop group*
  7. 
. * row 2
. gen group=(married==0)*(incwage>0)*(v25==0)*(agi2017<80000)*(calckids>0)*(sample
> justwomen==1)*(statefip==`l')
  8. 
. gen group1=perwt*avgtax*.2*group
  9. egen totgroup1b=sum(group1)
 10. 
. drop group*
 11. 
. * row 3
. gen group=(married==1)*(incwage>0)*(agi2017<80000)*(calckids>0)*(samplejustwomen
> ==1)*(statefip==`l')
 12. 
. gen group1=perwt*avgtax*.2*group
 13. egen totgroup1c=sum(group1)
 14. 
. drop group*
 15. 
. * row 4
. gen group=(married==1)*(totincwage>incwage)*(agi2017<80000)*(calckids>0)*(sample
> justwomen==1)*(statefip==`l')
 16. 
. gen group1=perwt*avgtax*.05*group
 17. egen totgroup1d=sum(group1)
 18. 
. drop group*
 19. 
. 
. * row 5: sum up non-mom and potential spouse
. gen person1=(incwage>0)*(agi2017<80000)*(calckids>0)*(samplenotmoms==1)*(statefi
> p==`l')
 20. gen person2=(totincwage>incwage)*(agi2017<80000)*(calckids>0)*(samplenotmoms=
> =1)*(married==1)*(statefip==`l')
 21. 
. gen group1=(perwt*person1+spouseperwt*person2)*avgtax*.05
 22. egen totgroup1e=sum(group1)
 23. 
. drop group*
 24. 
. forvalues i=1/1{
 25.         di totgroup`i'a+totgroup`i'b+totgroup`i'c+totgroup`i'd+totgroup`i'e
 26. }
 27. 
. replace adultsstopwork=totgroup1a+totgroup1b+totgroup1c+totgroup1d+totgroup1e if
>  statefip==`l'
 28. drop totgroup* person*
 29.         }
-> statefip = alabama
5808.4655
(5,172 real changes made)
-> statefip = alaska
783.64547
(874 real changes made)
-> statefip = arizona
8173.2461
(7,562 real changes made)
-> statefip = arkansas
4109.7156
(3,456 real changes made)
-> statefip = california
38323.916
(43,507 real changes made)
-> statefip = colorado
4928.4081
(6,370 real changes made)
-> statefip = connecticut
3330.6763
(3,871 real changes made)
-> statefip = delaware
1090.7807
(931 real changes made)
-> statefip = district of columbia
487.02066
(564 real changes made)
-> statefip = florida
23579.908
(20,061 real changes made)
-> statefip = georgia
13487.379
(11,810 real changes made)
-> statefip = hawaii
1277.8331
(1,588 real changes made)
-> statefip = idaho
2046.0788
(1,966 real changes made)
-> statefip = illinois
14009.414
(14,298 real changes made)
-> statefip = indiana
7963.3833
(7,495 real changes made)
-> statefip = iowa
3575.1042
(3,530 real changes made)
-> statefip = kansas
3448.4856
(3,304 real changes made)
-> statefip = kentucky
5538.0849
(5,183 real changes made)
-> statefip = louisiana
6538.229
(5,033 real changes made)
-> statefip = maine
1098.4139
(1,221 real changes made)
-> statefip = maryland
5552.2717
(6,772 real changes made)
-> statefip = massachusetts
5515.0958
(7,216 real changes made)
-> statefip = michigan
11534.522
(10,650 real changes made)
-> statefip = minnesota
5379.5293
(6,024 real changes made)
-> statefip = mississippi
4452.4293
(3,401 real changes made)
-> statefip = missouri
7648.9786
(6,944 real changes made)
-> statefip = montana
934.74113
(1,054 real changes made)
-> statefip = nebraska
2366.7886
(2,264 real changes made)
-> statefip = nevada
3890.6651
(3,254 real changes made)
-> statefip = new hampshire
998.69205
(1,348 real changes made)
-> statefip = new jersey
8435.1438
(10,148 real changes made)
-> statefip = new mexico
2758.1445
(2,138 real changes made)
-> statefip = new york
18988.403
(21,016 real changes made)
-> statefip = north carolina
12032.868
(11,374 real changes made)
-> statefip = north dakota
733.61434
(843 real changes made)
-> statefip = ohio
14419.987
(12,886 real changes made)
-> statefip = oklahoma
5199.6732
(4,489 real changes made)
-> statefip = oregon
3757.805
(4,338 real changes made)
-> statefip = pennsylvania
12272.624
(13,135 real changes made)
-> statefip = rhode island
960.94186
(1,066 real changes made)
-> statefip = south carolina
7154.8734
(5,380 real changes made)
-> statefip = south dakota
1041.6501
(1,014 real changes made)
-> statefip = tennessee
8134.3022
(7,389 real changes made)
-> statefip = texas
34501.295
(33,086 real changes made)
-> statefip = utah
3014.735
(4,001 real changes made)
-> statefip = vermont
553.46568
(608 real changes made)
-> statefip = virginia
7698.8162
(9,580 real changes made)
-> statefip = washington
6488.5094
(8,383 real changes made)
-> statefip = west virginia
1866.371
(1,885 real changes made)
-> statefip = wisconsin
6683.8273
(6,207 real changes made)
-> statefip = wyoming
604.35169
(701 real changes made)

. 
. 
. table statefip [fw=newnumkidswt17], c(n all mean faminc mean stpoorkids mean sts
> tillpoor mean adultsstopwork)   

----------------------------------------------------------------------------------
   state (fips code) |      N(all)    __000003    __000004    __000005    __000006
---------------------+------------------------------------------------------------
             alabama |     1072619     66712.3      179620      116878    5808.465
              alaska |     183,657    97484.54       21932       12341    783.6454
             arizona |     1611887    76996.34      271752      170329    8173.246
            arkansas |     699,235    65490.99       93139       58544    4109.716
          california |     8972903    91349.89     1894790     1445588    38323.91
            colorado |     1244439    91692.95      145925      104456    4928.408
         connecticut |     734,631    109132.9       88972       62458    3330.676
            delaware |     201,434    84214.91       29904       19477    1090.781
district of columbia |     122,086    107946.3       27092       19405    487.0207
             florida |     4153042    76736.09      796211      584626    23579.91
             georgia |     2482557    75374.12      398825      262912    13487.38
              hawaii |     300,554     91817.1       51291       38492    1277.833
               idaho |     438,588    75154.62       41114       29681    2046.079
            illinois |     2868673    88617.33      392586      258318    14009.41
             indiana |     1554411    73367.98      202834      132228    7963.383
                iowa |     724,240    79848.44       49532       26221    3575.104
              kansas |     699,960    80478.14       69167       42639    3448.486
            kentucky |     997,013    69370.48      153778      106131    5538.085
           louisiana |     1096514    69512.07      222927      140390    6538.229
               maine |     250,233    78288.16       19998       11739    1098.414
            maryland |     1333160    100941.3      199312      150669    5552.271
       massachusetts |     1353409      110500      188403      138671    5515.096
            michigan |     2150064    77686.08      276154      168694    11534.52
           minnesota |     1277407    94058.19       98339       62498    5379.529
         mississippi |     704,684     60760.7      132189       79806    4452.429
            missouri |     1367950    74920.35      168315      115551    7648.979
             montana |     225,661    79215.97       20721       13413    934.7411
            nebraska |     469,882    78961.84       35951       20606    2366.789
              nevada |     676,816    78298.05      101873       63830    3890.665
       new hampshire |     255,663    104978.3       22941       15596     998.692
          new jersey |     1959407    109519.3      283879      215005    8435.144
          new mexico |     481,733     64028.5       78374       50487    2758.145
            new york |     4089327    93507.95      789686      593655     18988.4
      north carolina |     2275732     73949.6      357083      231309    12032.87
        north dakota |     170,429    86614.85       11472        9010    733.6143
                ohio |     2566094    78205.65      310743      193788    14419.99
            oklahoma |     946,117    69044.88      120308       70265    5199.673
              oregon |     863,901    79402.68      104457       63633    3757.805
        pennsylvania |     2625434    86334.18      358286      241296    12272.62
        rhode island |     204,564    87302.44       24952       18064    960.9418
      south carolina |     1086972    67920.43      172990      117111    7154.874
        south dakota |     207,792    86231.59       19907       10057     1041.65
           tennessee |     1484983    74537.92      226040      153330    8134.302
               texas |     7285182    80633.16     1201392      794488     34501.3
                utah |     919,123     84812.2       82239       52580    3014.735
             vermont |     114,380    76924.12       10720        6404    553.4657
            virginia |     1848761    93425.13      272535      205797    7698.816
          washington |     1629912       94791      183163      122917    6488.509
       west virginia |     365,941    62971.41       60551       38250    1866.371
           wisconsin |     1269944    83335.01       98868       57344    6683.827
             wyoming |     136,595    76318.72       13748       10242    604.3517
----------------------------------------------------------------------------------

. 
. 
. levelsof statefip, local(levels)
1 2 4 5 6 8 9 10 11 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
>  34 35 36 37 38 39 40 41 42 44 45 46 47 48 49 50 51 53 54 55 56

.         foreach l of local levels {
  2.         di "-> statefip = `: label (statefip) `l''"
  3. 
. gen group=(married==0)*(incwage>0)*(v25>0)*(agi2017<80000)*(calckids>0)*(samplej
> ustwomen==1)*(statefip==`l')
  4. 
. gen group4=newnumkidswt17*avgtax*.4*group*(poor==0)*poorctc21nother
  5. egen totgroup4a=sum(group4)
  6. 
. gen group5=newnumkidswt17*avgtax*.4*group*(poor==1)*(poorctc21==0)*poorctc21noth
> er
  7. egen totgroup5a=sum(group5)
  8. 
. drop group*
  9. 
. * row 2
. gen group=(married==0)*(incwage>0)*(v25==0)*(agi2017<80000)*(calckids>0)*(sample
> justwomen==1)*(statefip==`l')
 10. 
. gen group4=newnumkidswt17*avgtax*.2*group*(poor==0)*poorctc21nother
 11. egen totgroup4b=sum(group4)
 12. 
. gen group5=newnumkidswt17*avgtax*.2*group*(poor==1)*(poorctc21==0)*poorctc21noth
> er
 13. egen totgroup5b=sum(group5)
 14. 
. drop group*
 15. 
. * row 3
. gen group=(married==1)*(incwage>0)*(agi2017<80000)*(calckids>0)*(samplejustwomen
> ==1)*(statefip==`l')
 16. 
. gen group4=newnumkidswt17*avgtax*.2*group*(poor==0)*poorctc21nother
 17. egen totgroup4c=sum(group4)
 18. 
. gen group5=newnumkidswt17*avgtax*.2*group*(poor==1)*(poorctc21==0)*poorctc21noth
> er
 19. egen totgroup5c=sum(group5)
 20. 
. drop group*
 21. 
. * row 4
. gen group=(married==1)*(totincwage>incwage)*(agi2017<80000)*(calckids>0)*(sample
> justwomen==1)*(statefip==`l')
 22. 
. gen group4=newnumkidswt17*avgtax*.05*group*(poor==0)*poorctc21notspouse
 23. egen totgroup4d=sum(group4)
 24. 
. gen group5=newnumkidswt17*avgtax*.05*group*(poor==1)*(poorctc21==0)*poorctc21not
> spouse
 25. egen totgroup5d=sum(group5)
 26. 
. drop group*
 27. 
. 
. * row 5: sum up non-mom and potential spouse
. gen person1=(incwage>0)*(agi2017<80000)*(calckids>0)*(samplenotmoms==1)*(statefi
> p==`l')
 28. gen person2=(totincwage>incwage)*(agi2017<80000)*(calckids>0)*(samplenotmoms=
> =1)*(married==1)*(statefip==`l')
 29. 
. gen group4=(newnumkidswt17*person1)*avgtax*.05*(poor==0)*poorctc21nother+(newnum
> kidswt17*person2)*avgtax*.05*(poor==0)*poorctc21notspouse
 30. egen totgroup4e=sum(group4)
 31. 
. gen group5=(newnumkidswt17*person1)*avgtax*.05*(poor==1)*(poorctc21==0)*poorctc2
> 1nother+newnumkidswt17*person2*avgtax*.05*(poor==1)*(poorctc21==0)*poorctc21nots
> pouse
 32. egen totgroup5e=sum(group5)
 33. 
. drop group*
 34. 
. di (ststillpoor+totgroup4a+totgroup4b+totgroup4c+totgroup4d+totgroup4e+totgroup5
> a+totgroup5b+totgroup5c+totgroup5d+totgroup5e) 
 35. 
. replace dynamicantipovkid=ststillpoor+totgroup4a+totgroup4b+totgroup4c+totgroup4
> d+totgroup4e+totgroup5a+totgroup5b+totgroup5c+totgroup5d+totgroup5e if statefip=
> =`l'
 36. 
. drop totgroup* person*
 37. 
. }       
-> statefip = alabama
122211.6
(5,172 real changes made)
-> statefip = alaska
117339.72
(874 real changes made)
-> statefip = arizona
123268.73
(7,562 real changes made)
-> statefip = arkansas
120561.42
(3,456 real changes made)
-> statefip = california
144855.13
(43,507 real changes made)
-> statefip = colorado
120843.96
(6,370 real changes made)
-> statefip = connecticut
119585.13
(3,871 real changes made)
-> statefip = delaware
118129.7
(931 real changes made)
-> statefip = district of columbia
117293.9
(564 real changes made)
-> statefip = florida
137053.18
(20,061 real changes made)
-> statefip = georgia
129360.5
(11,810 real changes made)
-> statefip = hawaii
117567.99
(1,588 real changes made)
-> statefip = idaho
118101.05
(1,966 real changes made)
-> statefip = illinois
127874.81
(14,298 real changes made)
-> statefip = indiana
123588.96
(7,495 real changes made)
-> statefip = iowa
119588.48
(3,530 real changes made)
-> statefip = kansas
119141.19
(3,304 real changes made)
-> statefip = kentucky
120695.67
(5,183 real changes made)
-> statefip = louisiana
122881.95
(5,033 real changes made)
-> statefip = maine
117593.33
(1,221 real changes made)
-> statefip = maryland
121696.72
(6,772 real changes made)
-> statefip = massachusetts
121118.21
(7,216 real changes made)
-> statefip = michigan
125710.6
(10,650 real changes made)
-> statefip = minnesota
120629.98
(6,024 real changes made)
-> statefip = mississippi
120510.72
(3,401 real changes made)
-> statefip = missouri
123200.32
(6,944 real changes made)
-> statefip = montana
117677.09
(1,054 real changes made)
-> statefip = nebraska
119015.46
(2,264 real changes made)
-> statefip = nevada
120323.96
(3,254 real changes made)
-> statefip = new hampshire
117409.66
(1,348 real changes made)
-> statefip = new jersey
124111.27
(10,148 real changes made)
-> statefip = new mexico
119216.03
(2,138 real changes made)
-> statefip = new york
132065.65
(21,016 real changes made)
-> statefip = north carolina
126870.4
(11,374 real changes made)
-> statefip = north dakota
117521.64
(843 real changes made)
-> statefip = ohio
127856.78
(12,886 real changes made)
-> statefip = oklahoma
121033.69
(4,489 real changes made)
-> statefip = oregon
119744.4
(4,338 real changes made)
-> statefip = pennsylvania
126981.83
(13,135 real changes made)
-> statefip = rhode island
117500.11
(1,066 real changes made)
-> statefip = south carolina
122979.23
(5,380 real changes made)
-> statefip = south dakota
117447.72
(1,014 real changes made)
-> statefip = tennessee
122580.98
(7,389 real changes made)
-> statefip = texas
145835.9
(33,086 real changes made)
-> statefip = utah
119339.81
(4,001 real changes made)
-> statefip = vermont
117220.16
(608 real changes made)
-> statefip = virginia
122815.51
(9,580 real changes made)
-> statefip = washington
121505.27
(8,383 real changes made)
-> statefip = west virginia
118338.89
(1,885 real changes made)
-> statefip = wisconsin
122388.96
(6,207 real changes made)
-> statefip = wyoming
117311.93
(701 real changes made)

. 
. gen poorrate1=100*stpoorkids/stnumkids

. gen poorrate2=100*ststillpoor/stnumkids

. gen poorrate3=100*dynamicantipovkid/stnumkids

. 
. table statefip [fw=newnumkidswt17], c(n all mean faminc mean stpoorkids mean sts
> tillpoor mean dynamicantipovkid ) 

----------------------------------------------------------------------------------
   state (fips code) |      N(all)    __000003    __000004    __000005    __000006
---------------------+------------------------------------------------------------
             alabama |     1072619     66712.3      179620      116878    122211.6
              alaska |     183,657    97484.54       21932       12341    12802.72
             arizona |     1611887    76996.34      271752      170329    176719.7
            arkansas |     699,235    65490.99       93139       58544    62227.41
          california |     8972903    91349.89     1894790     1445588     1473565
            colorado |     1244439    91692.95      145925      104456      108422
         connecticut |     734,631    109132.9       88972       62458    65165.13
            delaware |     201,434    84214.91       29904       19477     20728.7
district of columbia |     122,086    107946.3       27092       19405     19820.9
             florida |     4153042    76736.09      796211      584626    604801.2
             georgia |     2482557    75374.12      398825      262912    275394.5
              hawaii |     300,554     91817.1       51291       38492    39181.99
               idaho |     438,588    75154.62       41114       29681    30904.05
            illinois |     2868673    88617.33      392586      258318    269314.8
             indiana |     1554411    73367.98      202834      132228      138939
                iowa |     724,240    79848.44       49532       26221    28931.48
              kansas |     699,960    80478.14       69167       42639     44902.2
            kentucky |     997,013    69370.48      153778      106131    109948.7
           louisiana |     1096514    69512.07      222927      140390      146394
               maine |     250,233    78288.16       19998       11739    12454.33
            maryland |     1333160    100941.3      199312      150669    155487.7
       massachusetts |     1353409      110500      188403      138671    142911.2
            michigan |     2150064    77686.08      276154      168694    177526.6
           minnesota |     1277407    94058.19       98339       62498    66249.98
         mississippi |     704,684     60760.7      132189       79806    83438.72
            missouri |     1367950    74920.35      168315      115551    121873.3
             montana |     225,661    79215.97       20721       13413    14212.09
            nebraska |     469,882    78961.84       35951       20606    22743.46
              nevada |     676,816    78298.05      101873       63830    67275.96
       new hampshire |     255,663    104978.3       22941       15596    16127.66
          new jersey |     1959407    109519.3      283879      215005    222238.3
          new mexico |     481,733     64028.5       78374       50487    52825.03
            new york |     4089327    93507.95      789686      593655    608842.6
      north carolina |     2275732     73949.6      357083      231309    241301.4
        north dakota |     170,429    86614.85       11472        9010    9653.641
                ohio |     2566094    78205.65      310743      193788    204766.8
            oklahoma |     946,117    69044.88      120308       70265     74420.7
              oregon |     863,901    79402.68      104457       63633     66499.4
        pennsylvania |     2625434    86334.18      358286      241296    251399.8
        rhode island |     204,564    87302.44       24952       18064    18686.11
      south carolina |     1086972    67920.43      172990      117111    123212.2
        south dakota |     207,792    86231.59       19907       10057    10626.72
           tennessee |     1484983    74537.92      226040      153330      159033
               texas |     7285182    80633.16     1201392      794488    823445.9
                utah |     919,123     84812.2       82239       52580    55041.81
             vermont |     114,380    76924.12       10720        6404    6746.155
            virginia |     1848761    93425.13      272535      205797    211734.5
          washington |     1629912       94791      183163      122917    127544.3
       west virginia |     365,941    62971.41       60551       38250    39710.89
           wisconsin |     1269944    83335.01       98868       57344    62854.96
             wyoming |     136,595    76318.72       13748       10242    10675.93
----------------------------------------------------------------------------------

. 
. table statefip [fw=newnumkidswt17], c(mean adultsstopwork mean poorrate1 mean po
> orrate2 mean poorrate3 )

----------------------------------------------------------------------------------
   state (fips code) | mean(adults~k) mean(poorra~1) mean(poorra~2) mean(poorra~3)
---------------------+------------------------------------------------------------
             alabama |       5808.465       16.74593       10.89651       11.39376
              alaska |       783.6454       11.94183       6.719592       6.970997
             arizona |       8173.246       16.85925       10.56706       10.96353
            arkansas |       4109.716       13.32013       8.372579       8.899356
          california |       38323.91        21.1168       16.11059       16.42239
            colorado |       4928.408       11.72617       8.393823       8.712517
         connecticut |       3330.676       12.11111       8.501955       8.870458
            delaware |       1090.781       14.84556       9.669172       10.29057
district of columbia |       487.0207       22.19091       15.89453        16.2352
             florida |       23579.91       19.17175       14.07705       14.56285
             georgia |       13487.38       16.06509       10.59037       11.09318
              hawaii |       1277.833       17.06549       12.80702       13.03659
               idaho |       2046.079       9.374173       6.767399       7.046259
            illinois |       14009.41       13.68528        9.00479       9.388132
             indiana |       7963.383       13.04893       8.506631       8.938368
                iowa |       3575.104        6.83917       3.620485       3.994737
              kansas |       3448.486       9.881565       6.091634       6.414966
            kentucky |       5538.085       15.42387        10.6449       11.02781
           louisiana |       6538.229       20.33052        12.8033       13.35085
               maine |       1098.414       7.991752       4.691228       4.977095
            maryland |       5552.271       14.95034       11.30164        11.6631
       massachusetts |       5515.096       13.92063       10.24605       10.55935
            michigan |       11534.52       12.84399       7.845999       8.256805
           minnesota |       5379.529       7.698329       4.892568       5.186285
         mississippi |       4452.429       18.75862       11.32508       11.84059
            missouri |       7648.979       12.30418        8.44702       8.909194
             montana |       934.7411       9.182358       5.943871       6.297982
            nebraska |       2366.789        7.65107       4.385356        4.84025
              nevada |       3890.665        15.0518       9.430923       9.940066
       new hampshire |        998.692       8.973141       6.100218       6.308173
          new jersey |       8435.144       14.48801       10.97296       11.34212
          new mexico |       2758.145       16.26918       10.48029       10.96562
            new york |        18988.4        19.3109       14.51718       14.88858
      north carolina |       12032.87       15.69091       10.16416       10.60324
        north dakota |       733.6143       6.731249       5.286659       5.664318
                ohio |       14419.99       12.10957       7.551867       7.979707
            oklahoma |       5199.673       12.71597       7.426672       7.865908
              oregon |       3757.805       12.09132       7.365775       7.697572
        pennsylvania |       12272.62       13.64673       9.190709       9.575553
        rhode island |       960.9418       12.19765       8.830488       9.134604
      south carolina |       7154.874       15.91485       10.77406       11.33536
        south dakota |        1041.65       9.580254       4.839936       5.114112
           tennessee |       8134.302       15.22172       10.32537       10.70941
               texas |        34501.3        16.4909       10.90553       11.30302
                utah |       3014.735       8.947551       5.720671       5.988514
             vermont |       553.4657       9.372268       5.598881        5.89802
            virginia |       7698.816       14.74149       11.13162       11.45278
          washington |       6488.509        11.2376       7.541327       7.825224
       west virginia |       1866.371       16.54666       10.45251       10.85172
           wisconsin |       6683.827       7.785225       4.515475       4.949428
             wyoming |       604.3517       10.06479       7.498078       7.815752
----------------------------------------------------------------------------------

. 
. log close
      name:  <unnamed>
       log:  G:\My Drive\Research\CTC expansion\submission\ntj\stata replication f
> iles/output/tableA4.log
  log type:  text
 closed on:   3 Dec 2023, 18:19:59
----------------------------------------------------------------------------------
